-
For Every one want to have More color symbol for health Status column.
Dear Community Memebers, I saw many equations asking to have More color symbol for health Status column, so i added this post to be a simple reference to solve this issue and with your help and comme…18 · -
Re: Assistance Needed with PMO Formula.
Hi @Saj please try the following: 1: Create Helper Columns Task Status (Dropdown): This column should have values like "Not Started," "In Progress," "Completed," and &qu…1 · -
Re: How to add new criteria to the current formula
Hi @HZAR Please try the following formula: =IF([Buyer Status]@row = "cancel", "Not Required", IF([xx Proposed Settlement ($USD)]@row >= {Buyer Supervisor Limit}, "YES"…1 · -
Re: How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
Hi @ewestesen, please try the following: 1-ensure that your current Google Sheets data is imported into Smartsheet. You can do this by: Exporting the Google Sheet to an Excel format. Importing the Ex…2 · -
Re: Automation using reference cell
Hi @mpiza, To achieve the desired result in Smartsheet with WorkApps, where you want to automate the update of a "% Complete" column based on a calculated percentage in another column (whic…1 ·